create table dbo.ReportSchedule(
	[id] bigint not null primary key,
	[serverid] bigint null,
	[databaseid] bigint null,
	[IsActive] bit not null default 1,
	[delaydays] smallint not null,
	[timeofday] char(4) not null,
	[recipientemailaddresses] varchar(1000) not null,
	[lastreportcompiledate] smalldatetime null,
	[lastreportsenddate] smalldatetime null,
	[CreateName] varchar(50) not null,
	[CreateDate] datetime not null default current_timestamp,
	[ChangeName] varchar(50) null,
	[ChangeDate] datetime null)